﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace DB_NH.DB_Model.ZJK
{
    /// <summary>
    /// 专家信息
    /// </summary>
    [Serializable]
    public class ZJ_expert : Entity
    {
        #region 数据表名称
        public static readonly string TableName = "zj_expert";
        #endregion

        #region 数据表字段结构
        public struct Columns
        {
            /// <summary>
            /// 专家姓名
            /// </summary>
            public static readonly string zj_name = @"zj_name";

            /// <summary>
            /// 性别
            /// </summary>
            public static readonly string zj_sex = @"zj_sex";

            /// <summary>
            /// 身份证号
            /// </summary>
            public static readonly string zj_idcard_number = @"zj_idcard_number";

            /// <summary>
            /// 专家工作单位
            /// </summary>
            public static readonly string zj_company = @"zj_company";

            /// <summary>
            /// 出生年
            /// </summary>
            public static readonly string zj_birthdate_y = @"zj_birthdate_y";

            /// <summary>
            /// 出生月
            /// </summary>
            public static readonly string zj_birthdate_m = @"zj_birthdate_m";

            /// <summary>
            /// 专家学历
            /// </summary>
            public static readonly string zj_education = @"zj_education";

            /// <summary>
            /// 专家专业
            /// </summary>
            public static readonly string zj_professional = @"zj_professional";

            /// <summary>
            /// 专家学位
            /// </summary>
            public static readonly string zj_degree = @"zj_degree";

            /// <summary>
            /// 专家毕业院校
            /// </summary>
            public static readonly string zj_graduation = @"zj_graduation";

            /// <summary>
            /// 所属地区
            /// </summary>
            public static readonly string zj_area = @"zj_area";

            /// <summary>
            /// 所属城市
            /// </summary>
            public static readonly string zj_city = @"zj_city";

            /// <summary>
            /// 专家职务
            /// </summary>
            public static readonly string zj_position = @"zj_position";

            /// <summary>
            /// 专家职称
            /// </summary>
            public static readonly string zj_title = @"zj_title";

            /// <summary>
            /// 专家工作电话
            /// </summary>
            public static readonly string zj_tele_work = @"zj_tele_work";

            /// <summary>
            /// 专家家庭电话
            /// </summary>
            public static readonly string zj_tele_home = @"zj_tele_home";

            /// <summary>
            /// 专家手机
            /// </summary>
            public static readonly string zj_mobile = @"zj_mobile";

            /// <summary>
            /// 专家传真
            /// </summary>
            public static readonly string zj_fax = @"zj_fax";

            /// <summary>
            /// 专家电子邮件
            /// </summary>
            public static readonly string zj_email = @"zj_email";

            /// <summary>
            /// 专家通信地址
            /// </summary>
            public static readonly string zj_mail_address = @"zj_mail_address";

            /// <summary>
            /// 专家级别
            /// </summary>
            public static readonly string zj_level = @"zj_level";

            /// <summary>
            /// 专家简历
            /// </summary>
            public static readonly string zj_resume = @"zj_resume";

            /// <summary>
            /// 精通内容和产品
            /// </summary>
            public static readonly string zj_content_and_product = @"zj_content_and_product";

            /// <summary>
            /// 推荐意见
            /// </summary>
            public static readonly string zj_recommend_describe = @"zj_recommend_describe";

            /// <summary>
            /// 推荐单位
            /// </summary>
            public static readonly string zj_recommend_department = @"zj_recommend_department";
            
            /// <summary>
            /// 停用状态
            /// </summary>
            public static readonly string zj_stop_status = @"zj_stop_status";

            /// <summary>
            /// 停用说明
            /// </summary>
            public static readonly string zj_stop_describe = @"zj_stop_describe";
        }
        #endregion

        #region 字段
        /// <summary>
        /// 专家姓名
        /// </summary>
        public virtual string zj_name { get; set; }

        /// <summary>
        /// 性别
        /// </summary>
        public virtual string zj_sex { get; set; }

        /// <summary>
        /// 身份证号
        /// </summary>
        public virtual string zj_idcard_number { get; set; }

        /// <summary>
        /// 专家工作单位
        /// </summary>
        public virtual string zj_company { get; set; }

        /// <summary>
        /// 出生年
        /// </summary>
        public virtual string zj_birthdate_m { get; set; }

        /// <summary>
        /// 出生月
        /// </summary>
        public virtual string zj_birthdate_y { get; set; }

        /// <summary>
        /// 专家学历
        /// </summary>
        public virtual string zj_education { get; set; }

        /// <summary>
        /// 专家专业
        /// </summary>
        public virtual string zj_professional { get; set; }

        /// <summary>
        /// 专家学位
        /// </summary>
        public virtual string zj_degree { get; set; }

        /// <summary>
        /// 专家毕业院校
        /// </summary>
        public virtual string zj_graduation { get; set; }

        /// <summary>
        /// 所属地区
        /// </summary>
        public virtual string zj_area { get; set; }

        /// <summary>
        /// 所属城市
        /// </summary>
        public virtual string zj_city { get; set; }

        /// <summary>
        /// 专家职务
        /// </summary>
        public virtual string zj_position { get; set; }

        /// <summary>
        /// 专家职称
        /// </summary>
        public virtual string zj_title { get; set; }

        /// <summary>
        /// 专家工作电话
        /// </summary>
        public virtual string zj_tele_work { get; set; }

        /// <summary>
        /// 专家家庭电话
        /// </summary>
        public virtual string zj_tele_home { get; set; }

        /// <summary>
        /// 专家手机
        /// </summary>
        public virtual string zj_mobile { get; set; }

        /// <summary>
        /// 专家传真
        /// </summary>
        public virtual string zj_fax { get; set; }

        /// <summary>
        /// 专家电子邮件
        /// </summary>
        public virtual string zj_email { get; set; }

        /// <summary>
        /// 专家通信地址
        /// </summary>
        public virtual string zj_mail_address { get; set; }

        /// <summary>
        /// 专家级别
        /// </summary>
        public virtual string zj_level { get; set; }

        /// <summary>
        /// 工作简历
        /// </summary>
        public virtual string zj_resume { get; set; }

        /// <summary>
        /// 精通内容和产品
        /// </summary>
        public virtual string zj_content_and_product { get; set; }

        /// <summary>
        /// 推荐意见
        /// </summary>
        public virtual string zj_recommend_describe { get; set; }

        /// <summary>
        /// 推荐单位
        /// </summary>
        public virtual string zj_recommend_department { get; set; }

        /// <summary>
        /// 停用状态
        /// </summary>
        public virtual  DB_Common.ZJKConst.EXP_STOP_STATUS zj_stop_status { get; set; }

        /// <summary>
        /// 停用说明
        /// </summary>
        public virtual string zj_stop_describe { get; set; }

        /// <summary>
        /// 专家所属分类
        /// </summary>
        public virtual IList<ZJ_category> zj_categorys { get; set; }
        #endregion

        public ZJ_expert()
        {
            zj_categorys = new List<ZJ_category>();
        }
    }
}
